ALTER VIEW [dbo].[Report_Posts_TopRegions_View]    
AS    
SELECT ISNULL(Regions.RegionID,0) RegionID  
  ,Regions.Name    
  ,COUNT(Posts.PostID) AS totalPosts    
  ,convert(varchar(7), TimeCreated, 111) Years  
FROM Posts    
 LEFT JOIN Houses ON (Houses.HouseID = Posts.HouseID)    
 LEFT JOIN Regions ON (Regions.RegionID = Houses.Province)    
GROUP BY Regions.RegionID    
  ,Regions.Name
  ,TimeCreated